select
	a.*,
	(select count(1) from t_st_sub_account where promotionCode = a.promotionCode) promotionQty,
	(select count(1) from t_st_sub_account where promotionCode = a.promotionCode and idCardNumber is not null) promotionAndHasIdCardQty
from
	t_st_account a
